SELECT [Allele1], [Allele2], [Allele3], [Allele4], [Allele5],[Allele6], [Allele7], [Allele8], [Allele9], [Allele10],[Allele11], [Allele12], [Allele13], [Allele14], [Allele15],[Allele16], [Allele17], [Allele18], [Allele19], [Allele20],[Allele21], [Allele22], [Allele23], [Allele24], [Allele25],[Allele26], [Allele27], [Allele28], [Allele29], [Allele30],[Allele31], [Allele32], [Allele33], [Allele34], [Allele35],[Allele36], [Allele37], [Allele38], [Allele39], [Allele40],[Allele41], [Allele42], [Allele43], [Allele44], [Allele45],[Allele46], [Allele47], [Allele48], [Allele49], [Allele50],[Allele51], [Allele52], [Allele53], [Allele54], [Allele55],[Allele56], [Allele57], [Allele58], [Allele59], [Allele60],[Allele61], [Allele62], [Allele63], [Allele64], [Allele65],[Allele66], [Allele67], [Allele68], [Allele69], [Allele70],[Allele71], [Allele72], [Allele73], [Allele74], [Allele75],[Allele76], [Allele77], [Allele78], [Allele79], [Allele80],[Allele81], [Allele82], [Allele83], [Allele84], [Allele85],[Allele86], [Allele87], [Allele88], [Allele89], [Allele90],[Allele91], [Allele92], [Allele93], [Allele94], [Allele95],[Allele96], [Allele97], [Allele98], [Allele99], [Allele100],[Allele101], [Allele102], [Allele103], [Allele104], [Allele105],[Allele106], [Allele107], [Allele108], [Allele109], [Allele110],[Allele111], [Allele112], [Allele113], [Allele114], [Allele115],[Allele116], [Allele117], [Allele118], [Allele119], [Allele120],[Allele121], [Allele122], [Allele123], [Allele124], [Allele125],
CASE WHEN Allele1>0 then 1 ELSE 0 END
AS Al1,
CASE WHEN Allele2>0 then 1 ELSE 0 END
AS Al2,
CASE WHEN Allele3>0 then 1 ELSE 0 END
AS Al3,
CASE WHEN Allele4>0 then 1 ELSE 0 END
AS Al4,
CASE WHEN Allele5>0 then 1 ELSE 0 END
AS Al5,
CASE WHEN Allele6>0 then 1 ELSE 0 END
AS Al6,
CASE WHEN Allele7>0 then 1 ELSE 0 END
AS Al7,
CASE WHEN Allele8>0 then 1 ELSE 0 END
AS Al8,
CASE WHEN Allele9>0 then 1 ELSE 0 END
AS Al9,
CASE WHEN Allele10>0 then 1 ELSE 0 END
AS Al10,
CASE WHEN Allele11>0 then 1 ELSE 0 END
AS Al11,
CASE WHEN Allele12>0 then 1 ELSE 0 END
AS Al12,
CASE WHEN Allele13>0 then 1 ELSE 0 END
AS Al13,
CASE WHEN Allele14>0 then 1 ELSE 0 END
AS Al14,
CASE WHEN Allele15>0 then 1 ELSE 0 END
AS Al15,
CASE WHEN Allele16>0 then 1 ELSE 0 END
AS Al16,
CASE WHEN Allele17>0 then 1 ELSE 0 END
AS Al17,
CASE WHEN Allele18>0 then 1 ELSE 0 END
AS Al18,
CASE WHEN Allele19>0 then 1 ELSE 0 END
AS Al19,
CASE WHEN Allele20>0 then 1 ELSE 0 END
AS Al20,
CASE WHEN Allele21>0 then 1 ELSE 0 END
AS Al21,
CASE WHEN Allele22>0 then 1 ELSE 0 END
AS Al22,
CASE WHEN Allele23>0 then 1 ELSE 0 END
AS Al23,
CASE WHEN Allele24>0 then 1 ELSE 0 END
AS Al24,
CASE WHEN Allele25>0 then 1 ELSE 0 END
AS Al25,
CASE WHEN Allele26>0 then 1 ELSE 0 END
AS Al26,
CASE WHEN Allele27>0 then 1 ELSE 0 END
AS Al27,
CASE WHEN Allele28>0 then 1 ELSE 0 END
AS Al28,
CASE WHEN Allele29>0 then 1 ELSE 0 END
AS Al29,
CASE WHEN Allele30>0 then 1 ELSE 0 END
AS Al30,
CASE WHEN Allele31>0 then 1 ELSE 0 END
AS Al31,
CASE WHEN Allele32>0 then 1 ELSE 0 END
AS Al32,
CASE WHEN Allele33>0 then 1 ELSE 0 END
AS Al33,
CASE WHEN Allele34>0 then 1 ELSE 0 END
AS Al34,
CASE WHEN Allele35>0 then 1 ELSE 0 END
AS Al35,
CASE WHEN Allele36>0 then 1 ELSE 0 END
AS Al36,
CASE WHEN Allele37>0 then 1 ELSE 0 END
AS Al37,
CASE WHEN Allele38>0 then 1 ELSE 0 END
AS Al38,
CASE WHEN Allele39>0 then 1 ELSE 0 END
AS Al39,
CASE WHEN Allele40>0 then 1 ELSE 0 END
AS Al40,
CASE WHEN Allele41>0 then 1 ELSE 0 END
AS Al41,
CASE WHEN Allele42>0 then 1 ELSE 0 END
AS Al42,
CASE WHEN Allele43>0 then 1 ELSE 0 END
AS Al43,
CASE WHEN Allele44>0 then 1 ELSE 0 END
AS Al44,
CASE WHEN Allele45>0 then 1 ELSE 0 END
AS Al45,
CASE WHEN Allele46>0 then 1 ELSE 0 END
AS Al46,
CASE WHEN Allele47>0 then 1 ELSE 0 END
AS Al47,
CASE WHEN Allele48>0 then 1 ELSE 0 END
AS Al48,
CASE WHEN Allele49>0 then 1 ELSE 0 END
AS Al49,
CASE WHEN Allele50>0 then 1 ELSE 0 END
AS Al50,
CASE WHEN Allele51>0 then 1 ELSE 0 END
AS Al51,
CASE WHEN Allele52>0 then 1 ELSE 0 END
AS Al52,
CASE WHEN Allele53>0 then 1 ELSE 0 END
AS Al53,
CASE WHEN Allele54>0 then 1 ELSE 0 END
AS Al54,
CASE WHEN Allele55>0 then 1 ELSE 0 END
AS Al55,
CASE WHEN Allele56>0 then 1 ELSE 0 END
AS Al56,
CASE WHEN Allele57>0 then 1 ELSE 0 END
AS Al57,
CASE WHEN Allele58>0 then 1 ELSE 0 END
AS Al58,
CASE WHEN Allele59>0 then 1 ELSE 0 END
AS Al59,
CASE WHEN Allele60>0 then 1 ELSE 0 END
AS Al60,
CASE WHEN Allele61>0 then 1 ELSE 0 END
AS Al61,
CASE WHEN Allele62>0 then 1 ELSE 0 END
AS Al62,
CASE WHEN Allele63>0 then 1 ELSE 0 END
AS Al63,
CASE WHEN Allele64>0 then 1 ELSE 0 END
AS Al64,
CASE WHEN Allele65>0 then 1 ELSE 0 END
AS Al65,
CASE WHEN Allele66>0 then 1 ELSE 0 END
AS Al66,
CASE WHEN Allele67>0 then 1 ELSE 0 END
AS Al67,
CASE WHEN Allele68>0 then 1 ELSE 0 END
AS Al68,
CASE WHEN Allele69>0 then 1 ELSE 0 END
AS Al69,
CASE WHEN Allele70>0 then 1 ELSE 0 END
AS Al70,
CASE WHEN Allele71>0 then 1 ELSE 0 END
AS Al71,
CASE WHEN Allele72>0 then 1 ELSE 0 END
AS Al72,
CASE WHEN Allele73>0 then 1 ELSE 0 END
AS Al73,
CASE WHEN Allele74>0 then 1 ELSE 0 END
AS Al74,
CASE WHEN Allele75>0 then 1 ELSE 0 END
AS Al75,
CASE WHEN Allele76>0 then 1 ELSE 0 END
AS Al76,
CASE WHEN Allele77>0 then 1 ELSE 0 END
AS Al77,
CASE WHEN Allele78>0 then 1 ELSE 0 END
AS Al78,
CASE WHEN Allele79>0 then 1 ELSE 0 END
AS Al79,
CASE WHEN Allele80>0 then 1 ELSE 0 END
AS Al80,
CASE WHEN Allele81>0 then 1 ELSE 0 END
AS Al81,
CASE WHEN Allele82>0 then 1 ELSE 0 END
AS Al82,
CASE WHEN Allele83>0 then 1 ELSE 0 END
AS Al83,
CASE WHEN Allele84>0 then 1 ELSE 0 END
AS Al84,
CASE WHEN Allele85>0 then 1 ELSE 0 END
AS Al85,
CASE WHEN Allele86>0 then 1 ELSE 0 END
AS Al86,
CASE WHEN Allele87>0 then 1 ELSE 0 END
AS Al87,
CASE WHEN Allele88>0 then 1 ELSE 0 END
AS Al88,
CASE WHEN Allele89>0 then 1 ELSE 0 END
AS Al89,
CASE WHEN Allele90>0 then 1 ELSE 0 END
AS Al90,
CASE WHEN Allele91>0 then 1 ELSE 0 END
AS Al91,
CASE WHEN Allele92>0 then 1 ELSE 0 END
AS Al92,
CASE WHEN Allele93>0 then 1 ELSE 0 END
AS Al93,
CASE WHEN Allele94>0 then 1 ELSE 0 END
AS Al94,
CASE WHEN Allele95>0 then 1 ELSE 0 END
AS Al95,
CASE WHEN Allele96>0 then 1 ELSE 0 END
AS Al96,
CASE WHEN Allele97>0 then 1 ELSE 0 END
AS Al97,
CASE WHEN Allele98>0 then 1 ELSE 0 END
AS Al98,
CASE WHEN Allele99>0 then 1 ELSE 0 END
AS Al99,
CASE WHEN Allele100>0 then 1 ELSE 0 END
AS Al100,
CASE WHEN Allele101>0 then 1 ELSE 0 END
AS Al101,
CASE WHEN Allele102>0 then 1 ELSE 0 END
AS Al102,
CASE WHEN Allele103>0 then 1 ELSE 0 END
AS Al103,
CASE WHEN Allele104>0 then 1 ELSE 0 END
AS Al104,
CASE WHEN Allele105>0 then 1 ELSE 0 END
AS Al105,
CASE WHEN Allele106>0 then 1 ELSE 0 END
AS Al106,
CASE WHEN Allele107>0 then 1 ELSE 0 END
AS Al107,
CASE WHEN Allele108>0 then 1 ELSE 0 END
AS Al108,
CASE WHEN Allele109>0 then 1 ELSE 0 END
AS Al109,
CASE WHEN Allele110>0 then 1 ELSE 0 END
AS Al110,
CASE WHEN Allele111>0 then 1 ELSE 0 END
AS Al111,
CASE WHEN Allele112>0 then 1 ELSE 0 END
AS Al112,
CASE WHEN Allele113>0 then 1 ELSE 0 END
AS Al113,
CASE WHEN Allele114>0 then 1 ELSE 0 END
AS Al114,
CASE WHEN Allele115>0 then 1 ELSE 0 END
AS Al115,
CASE WHEN Allele116>0 then 1 ELSE 0 END
AS Al116,
CASE WHEN Allele117>0 then 1 ELSE 0 END
AS Al117,
CASE WHEN Allele118>0 then 1 ELSE 0 END
AS Al118,
CASE WHEN Allele119>0 then 1 ELSE 0 END
AS Al119,
CASE WHEN Allele120>0 then 1 ELSE 0 END
AS Al120,
CASE WHEN Allele121>0 then 1 ELSE 0 END
AS Al121,
CASE WHEN Allele122>0 then 1 ELSE 0 END
AS Al122,
CASE WHEN Allele123>0 then 1 ELSE 0 END
AS Al123,
CASE WHEN Allele124>0 then 1 ELSE 0 END
AS Al124,
CASE WHEN Allele125>0 then 1 ELSE 0 END
AS Al125
FROM [table_Primer 1 data.txt]